create external table jms_dm.dm_terminal_sign_summary_plan_sign_network_dt 
(
end_manage_region_code string COMMENT '末端网点所属管理大区编码' ,
end_manage_region_name string COMMENT '末端网点所属管理大区名称' ,
 end_agent_code string COMMENT '末端网点所属代理区编码' ,
end_agent_name string COMMENT '末端网点所属代理区名称' ,
end_provider_id string COMMENT '末端网点所属省份id' ,
end_provider_name string COMMENT '末端网点所属省份名称' ,
end_city_id string COMMENT '末端网点所属城市id' ,
end_city_name string COMMENT '末端网点所属城市名称' ,
end_area_id string COMMENT '末端网点所属区县id' ,
end_area_name string COMMENT '末端网点所属区县名称' ,
 end_center_code string COMMENT '末端发件中心/集散编码' ,
end_center_name string COMMENT '末端发件中心/集散名称' ,
 end_franchisee_code string COMMENT '末端网点所属加盟商编码' ,
end_franchisee_name string COMMENT '末端网点所属加盟商名称' ,
 final_sign_network_code string COMMENT '最终签收派件网点编码' ,
final_sign_network_name string COMMENT '最终签收派件网点名称' ,
final_sign_user_name string COMMENT '最后签收派件员名称' ,
need_sign_count bigint COMMENT '应签收汇总' ,
aging_sign_in_time_network string COMMENT '时效签收准点网点签收' ,
aging_sign_in_time_terminal_pdd string COMMENT '时效签收准点终端入库(桃花岛认证)' ,
aging_sign_in_time_terminal_other string COMMENT '时效签收准点终端入库(其他)' ,
aging_sign_in_time_proxy string COMMENT '时效签收准点代理点收入' ,
aging_sign_in_time_transfer string COMMENT '时效签收准点转邮' ,
aging_sign_in_time_count bigint COMMENT '时效签收准点汇总' ,

22_aging_sign_over_time_network string COMMENT '时效签收延误网点签收' ,
22_aging_sign_over_time_terminal_pdd string COMMENT '时效签收延误终端入库(桃花岛认证)' ,
22_aging_sign_over_time_terminal_other string COMMENT '时效签收延误终端入库(其他)' ,
22_aging_sign_over_time_proxy string COMMENT '时效签收延误代理点收入' ,
22_aging_sign_over_time_difficult string COMMENT '时效签收延误问题件' ,
22_aging_sign_over_time_other string COMMENT '时效签收延误其他' ,
22_aging_sign_over_time_transfer string COMMENT '时效签收延误转邮' ,
22_aging_sign_over_time_sign_count bigint COMMENT '时效签收延误已签收汇总' ,
22_aging_sign_over_time_nosign_count bigint COMMENT '时效签收延误未签收汇总' ,

24_aging_sign_over_time_network string COMMENT '时效签收延误网点签收' ,
24_aging_sign_over_time_terminal_pdd string COMMENT '时效签收延误终端入库(桃花岛认证)' ,
24_aging_sign_over_time_terminal_other string COMMENT '时效签收延误终端入库(其他)' ,
24_aging_sign_over_time_proxy string COMMENT '时效签收延误代理点收入' ,
24_aging_sign_over_time_difficult string COMMENT '时效签收延误问题件' ,
24_aging_sign_over_time_other string COMMENT '时效签收延误其他' ,
24_aging_sign_over_time_transfer string COMMENT '时效签收延误转邮' ,
24_aging_sign_over_time_sign_count bigint COMMENT '时效签收延误已签收汇总' ,
24_aging_sign_over_time_nosign_count bigint COMMENT '时效签收延误未签收汇总' ,

00_aging_sign_over_time_network string COMMENT '时效签收延误网点签收' ,
00_aging_sign_over_time_terminal_pdd string COMMENT '时效签收延误终端入库(桃花岛认证)' ,
00_aging_sign_over_time_terminal_other string COMMENT '时效签收延误终端入库(其他)' ,
00_aging_sign_over_time_proxy string COMMENT '时效签收延误代理点收入' ,
00_aging_sign_over_time_difficult string COMMENT '时效签收延误问题件' ,
00_aging_sign_over_time_other string COMMENT '时效签收延误其他' ,
00_aging_sign_over_time_transfer string COMMENT '时效签收延误转邮' ,
00_aging_sign_over_time_sign_count bigint COMMENT '时效签收延误已签收汇总' ,
00_aging_sign_over_time_nosign_count bigint COMMENT '时效签收延误未签收汇总' ,

aging_sign_24_count bigint COMMENT '时效签收24点前签收汇总' ,
actual_sign_in_time_network string COMMENT '实际签收准点网点签收' ,
actual_sign_in_time_terminal string COMMENT '实际签收准点驿站/快递柜' ,
actual_sign_in_time_proxy string COMMENT '实际签收准点代理点收入' ,
actual_sign_in_time_count bigint COMMENT '实际签收准点汇总' ,
actual_sign_over_time_network string COMMENT '实际签收延误网点签收' ,
actual_sign_over_time_terminal string COMMENT '实际签收延误驿站/快递柜' ,
actual_sign_over_time_proxy string COMMENT '实际签收延误代理点收入' ,
actual_sign_over_time_difficult string COMMENT '实际签收延误问题件' ,
actual_sign_over_time_other string COMMENT '实际签收延误其他' ,
actual_sign_over_time_sign_count bigint COMMENT '实际签收延误已签收汇总' ,
actual_sign_over_time_nosign_count bigint COMMENT '实际签收延误未签收汇总' ,
actual_sign_24_count bigint COMMENT '实际签收24点前签收汇总' ,
final_plan_sign_date date COMMENT '规划签收日期' ,
aging_sign_00_count  bigint COMMENT '时效签收24点前签收汇总' ,
aging_sign_22_count  bigint COMMENT '时效签收24点前签收汇总' ,
is_common_network string COMMENT '是否共配网点' ,

22_actual_sign_in_time_network  string COMMENT '22点前实际签收准点网点签收' ,
22_actual_sign_in_time_terminal  string COMMENT '22点前实际签收准点驿站/快递柜' ,
22_actual_sign_in_time_proxy  string COMMENT '22点前实际签收准点代理点收入' ,
22_actual_sign_in_time_count  bigint COMMENT '22点前实际签收准点汇总' ,
22_actual_sign_over_time_network  string COMMENT '22点前实际签收延误网点签收' ,
22_actual_sign_over_time_terminal  string COMMENT '22点前实际签收延误驿站/快递柜' ,
22_actual_sign_over_time_proxy  string COMMENT '22点前实际签收延误代理点收入' ,
22_actual_sign_over_time_difficult  string COMMENT '22点前实际签收延误问题件' ,
22_actual_sign_over_time_other  string COMMENT '22点前实际签收延误其他' ,
22_actual_sign_over_time_sign_count  bigint COMMENT '22点前实际签收延误已签收汇总' ,
22_actual_sign_over_time_nosign_count  bigint COMMENT '22点前实际签收延误未签收汇总' ,

24_actual_sign_in_time_network  string COMMENT '2224点实际签收准点网点签收' ,
24_actual_sign_in_time_terminal  string COMMENT '2224点实际签收准点驿站/快递柜' ,
24_actual_sign_in_time_proxy  string COMMENT '2224点实际签收准点代理点收入' ,
24_actual_sign_in_time_count  bigint COMMENT '2224点实际签收准点汇总' ,
24_actual_sign_over_time_network  string COMMENT '2224点实际签收延误网点签收' ,
24_actual_sign_over_time_terminal  string COMMENT '2224点实际签收延误驿站/快递柜' ,
24_actual_sign_over_time_proxy  string COMMENT '2224点实际签收延误代理点收入' ,
24_actual_sign_over_time_difficult  string COMMENT '2224点实际签收延误问题件' ,
24_actual_sign_over_time_other  string COMMENT '2224点实际签收延误其他' ,
24_actual_sign_over_time_sign_count bigint COMMENT '2224点实际签收延误已签收汇总' ,
24_actual_sign_over_time_nosign_count bigint COMMENT '2224实际签收延误未签收汇总' ,

00_actual_sign_in_time_network  string COMMENT '超24点实际签收准点网点签收' ,
00_actual_sign_in_time_terminal  string COMMENT '超24点实际签收准点驿站/快递柜' ,
00_actual_sign_in_time_proxy  string COMMENT '超24点实际签收准点代理点收入' ,
00_actual_sign_in_time_count  bigint COMMENT '超24点实际签收准点汇总' ,
00_actual_sign_over_time_network  string COMMENT '超24点实际签收延误网点签收' ,
00_actual_sign_over_time_terminal  string COMMENT '超24点实际签收延误驿站/快递柜' ,
00_actual_sign_over_time_proxy  string COMMENT '超24点实际签收延误代理点收入' ,
00_actual_sign_over_time_difficult  string COMMENT '超24点实际签收延误问题件' ,
00_actual_sign_over_time_other  string COMMENT '超24点实际签收延误其他' ,
00_actual_sign_over_time_sign_count bigint COMMENT '超24点实际签收延误已签收汇总' ,
00_actual_sign_over_time_nosign_count bigint COMMENT '超24点实际签收延误未签收汇总' ,
actual_sign_22_count  bigint COMMENT '22点签收量' ,
actual_sign_00_count  bigint COMMENT '24点前前签收量')
comment '末端时效规划签收网点维度汇总'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_terminal_sign_summary_plan_sign_network_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
alter table jms_dm.dm_terminal_sign_summary_plan_sign_network_dt add columns (
     order_source_name  string comment'订单来源'
) cascade;
